How to: Print page numbers that include the full number of pages.
Solution:
In the Report Design view, select the 'Insert' menu and select 'Page Number...'. Select the 'Page N of M' radio button to add full page numbers to a printed report.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the 'Insert' menu and select 'Page Number...'. (The Page Number dialog box appears.)
Page Numbers dialog box
6) Select the 'Page N of M' radio button in the 'Format' group to insert the page number and the total number of pages.
7) To select the position of the page numbers, do one of the following:
a) Select the 'Top of Page (Header)' radio button in the 'Position' group to insert the page number at the top of the report.
b) Select the 'Bottom of Page (Footer)' radio button to insert the page number at the bottom of the report.
8) To select the location (alignment) of the page number, do the following:
a) Click 'Alignment' down arrow. (A drop-down list appears.)
b) Select the desired location from the 'Alignment' drop-down list.
9) (Optional) Clear the 'Show Number on First Page' check box to remove the page number from the first page of the printed report.
10) Click 'OK'.
11) Select the 'File' menu and select 'Save' to save changes to the report.